css
c
ajax
mysql
database
xcode
android
ruby-on-rails
objective-c
visual-studio
silverlight
flash
json
algorithm
facebook
cocoa
apache
asp
api
postgresql
If you want to see it right away try disabling buffering
<add name="MySqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider" connectionStringName="MySqlConnection" maxEventDetailsLength="1073741823" buffer="true" bufferMode="Logging"/>
change to
<add name="MySqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider" connectionStringName="MySqlConnection" maxEventDetailsLength="1073741823" buffer="false" bufferMode="Logging"/>
This should stop the delay caused by buffering and you should see the rows appear right away.
Plus you may want to decrease your minInterval on the profiles to something quick like "00:00:01" :)
You can read more about buffering here:
http://msdn.microsoft.com/en-us/library/ms178708%28v=vs.80%29.aspx
On a live system it maybe a good idea to leave buffering in place in case you think your SQL server might get overloaded with lots of events firing.
OR
Ive found i can force it save to the log by:
1 : start your project in visual studio 2 : click the button 3 : Stop the project and then start it again 4 : Check in the database you should see an event logged
Try temporarily replacing the SqlWebEventProvider with a TraceWebEventProvider to see if the problem lies in ASP.NET WebEvents or in accessing the SQL database.
The TraceWebEventProvider should avoid permission related problems.
Updated
web.config:
<system.web> ... <providers> <clear/> <add name="TraceEventProvider" type="System.Web.Management.TraceWebEventProvider, System.Web" buffer="false" bufferMode="" maxEventLength="4096" maxSize="4096" maxMessagesPerNotification="1" /> </providers> ... <rules> <clear/> <add name="All Audits Default" eventName="All Audits" provider="TraceEventProvider" profile="Audit Logs"/> <add name="All Errors Default" eventName="All Errors" provider="TraceEventProvider" profile="Error Logs"/> </rules> ... </system.web> ...